class CreateYoutubes < ActiveRecord::Migration
  def self.up
    create_table :youtubes do |t|
      t.string :video_id
      t.string :published
      t.string :updated
      t.integer :upload_day
      t.integer :upload_month
      t.integer :upload_year
      t.string :title
      t.text :description
      t.string :author
      t.string :author_youtube_uri
      t.string :comment_feed
      t.string :comment_count
      t.string :category
      t.string :keywords
      t.string :player_url
      t.string :number_of_raters
      t.string :average_rating
      t.string :favorite_count
      t.string :view_count
      
      t.references :tag

      t.timestamps
    end
  end

  def self.down
    drop_table :youtubes
  end
end
